package com.MRYIN.mapper;

import com.MRYIN.pojo.Payments;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;

import java.util.List;

/**
 * @program: SHYC_03
 * @description: 款项
 * @author: Mr.YIN
 * @create: 2021-02-23 12:47
 **/
@Mapper
public interface PaymentsMapper {

    int insertPayment(Payments payments);

    List<Payments> queryAllPayments();

    /**
     *  通过该项目号所有的
     * @param PAY_PRJCODE
     * @return
     */
    List<Payments> queryAllPaymentsByPAY_PRJCODE(String PAY_PRJCODE);

    /**
     *  通过款项的名称来查找
     * @param PAY_NAME
     * @return
     */
    List<Payments> queryAllPaymentsByPAY_NAME(String PAY_NAME);

    /**
     *  通过款项编号，或项目号来查询
     * @param PAY_CODE
     * @return
     */
    List<Payments> queryAllPaymentsByPAY_CODEOrPAY_PRJCODE(@Param("PAY_CODE")String PAY_CODE,@Param("PAY_PRJCODE")String PAY_PRJCODE);

}
